# -*- coding: utf-8 -*-
from app import db
__author__ = 'jarvis'


class User(db.Model):
    __tablename__ = 'xw_user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    openid = db.Column(db.String(28))  # 微信公众号标识
    libusername = db.Column(db.String(64))          # 图书馆用户名
    libpwd = db.Column(db.String(64))               # 图书馆密码
    stuid = db.Column(db.String(8))                 # 学号
    username = db.Column(db.String(64))             # 真实姓名
    gender = db.Column(db.String(8))                # 性别
    createtime = db.Column(db.DATETIME)             # 创建日期
    bindstate = db.Column(db.INT)                   # 绑定状态






